How to: Control order in which cursor moves through fields in a form.
Solution:
In the Form Design view, select the 'View' menu and select 'Tab Order' to control the order in which the cursor moves.
1) If the Database window is not activated, activate the Database window.
2) Click the 'Forms' tab in the Database window.
Forms tab
3) Select the desired form from the list box. (The selected form is highlighted.)
4) Click 'Design'. (The selected form appears in Design view, and the floating Toolbox appears.)
5) Select the 'View' menu and select 'Tab Order...'. (The Tab Order dialog box appears.)
6) Select the desired radio button for the section in which to change the tab order, in the 'Section' group.
NOTE: The possible sections in a form could be 'Form Header', 'Detail', and 'Form Footer'.
Tab Order
7) Move the fields to the desired order in the 'Custom Order' list box.
NOTE 1: To move a field, select it and drag it to the desired location in the list (i.e., on top of the field which it is to be above).
NOTE 2: Click 'Auto Order' to have Access automatically order the tabs.
8) Click 'OK'. (The Tab Order dialog box closes.)
9) Select the 'File' menu and select 'Save' to save the form.
